Basic Structure of the XML File
The following section gives a high-level overview of the contents of a typical aPriori spreadsheet report XML file. For more detailed information, see the XML Reference section starting at "XML Configuration File Reference" on page 1.
<?xml version="1.0" encoding="utf-8"?>
<reports templatePath="templates/costdriver.report.template.xls"
traverseAssemblies="true">
<CostModelWatchpoints sheetName="apOutput">
</CostModelWatchpoints>
...
<CostModelWatchpoints>...</CostModelWatchPoints>
</reports>
A <reports> tag can contain any number of <CostModelWatchPoints> tags, each of which represents a logical group of data to be generated. In the case of the data going to Excel, each <CostModelWatchpoints> section generates data to a single worksheet (named by the 'sheetName' attribute). For example:
<CostModelWatchpoints sheetName="apOutput">
<Node name="*" isLeaf="true" suppressZeros="false" tag="first">
<CSL>
<Formula>materialCost</Formula>
<Formula>laborCost</Formula>
<Formula>directOverheadCost</Formula>
<Formula>setupCostPerPart</Formula>
<Formula>expendableToolingCostPerPart</Formula>
<Formula>targetCost</Formula>
</CSL>
</Node>
</CostModelWatchpoints>